<?php

    /***************************************************************************
    *                            Dolphin Smart Community Builder
    *                              -------------------
    *     begin                : Mon Mar 23 2006
    *     copyright            : (C) 2007 BoonEx Group
    *     website              : http://www.boonex.com
    * This file is part of Dolphin - Smart Community Builder
    *
    * Dolphin is free software; you can redistribute it and/or modify it under
    * the terms of the GNU General Public License as published by the
    * Free Software Foundation; either version 2 of the
    * License, or  any later version.
    *
    * Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
    * without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    * See the GNU General Public License for more details.
    * You should have received a copy of the GNU General Public License along with Dolphin,
    * see license.txt file; if not, write to marketing@boonex.com
    ***************************************************************************/

    require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolModuleDb.php' );

    class BxFaceBookConnectDb extends BxDolModuleDb 
    {
        var $_oConfig;
        var $sTablePrefix;

    	/**
    	 * Constructor.
    	 */
    	function BxFaceBookConnectDb(&$oConfig)
        {
    		parent::BxDolModuleDb();		

            $this -> _oConfig = $oConfig;
    	    $this -> sTablePrefix = $oConfig -> getDbPrefix();
        }

        /**
         * Check fb profile id
         * 
         * @param $iFbUid integer
         * @param $sOldFbUid string
         * @return integer
         */
        function getProfileId($iFbUid, $sOldFbUid = '')
        {
        	$iFbUid = (int) $iFbUid;
			$sOldFbUid = $sOldFbUid 
				? process_db_input($sOldFbUid, BX_TAGS_STRIP, BX_SLASHES_AUTO)
				: '';

        	//-- new auth method --//
        	$sQuery = "SELECT `id_profile` FROM `{$this -> sTablePrefix}accounts` WHERE 
        		`fb_profile` = {$iFbUid} LIMIT 1";

        	$iProfileId = $this -> getOne($sQuery);
        	//--

        	//-- old auth method (will need remove it in a feature version) --//
        	//try get profile's id used the old auth method :(
        	if(!$iProfileId && $sOldFbUid) {
        		$sQuery = "SELECT `ID` FROM `Profiles` WHERE `FacebookProfile` = '{$sOldFbUid}' LIMIT 1";
            	$iProfileId =  $this -> getOne($sQuery);

            	//update Fb uid
            	if($iProfileId) {
            		$this -> saveFbUid($iProfileId, $iFbUid);
            	}
        	}
			//--

        	return $iProfileId;
        }

        /**
         *  Save new Fb uid 
         *  
         * @param $iProfileId integer
         * @param $iFbUid integer
         * @return void
         */
        function saveFbUid($iProfileId, $iFbUid)
        {
        	$iProfileId = (int) $iProfileId;
        	$iFbUid = (int) $iFbUid;

        	$sQuery = "REPLACE INTO `{$this -> sTablePrefix}accounts` 
            			SET `id_profile` = {$iProfileId}, `fb_profile` = {$iFbUid}";

			$this -> query($sQuery);
        }

        /**
         * Delete Fb's uid
         * 
         * @param $iProfileId integer
         * @return void
         */
        function deleteFbUid($iProfileId)
        {
        	$iProfileId = (int) $iProfileId;
        	$sQuery = "DELETE FROM `{$this -> sTablePrefix}accounts` 
        		WHERE `id_profile` = {$iProfileId}";

        	$this -> query($sQuery);
        }

        /**
         * Make as friends
         * 
         * @param $iMemberId integer
         * @param $iProfileId intger
         * @return void
         */
        function makeFriend($iMemberId, $iProfileId)
        {
        	$iMemberId = (int) $iMemberId;
        	$iProfileId = (int) $iProfileId;

        	$sQuery = "INSERT INTO `sys_friend_list` SET 
        		`ID` = '{$iMemberId}', `Profile` = '{$iProfileId}', `Check` = 1";

        	$this -> query($sQuery);
        }

        /**
         * Create new profile;
         *
         * @param  : (array) $aProfileFields    - `Profiles` table's fields;
         * @return : (integer)  - profile's Id;
         */
        function createProfile(&$aProfileFields) 
        {
            $sFields = null;

            // procces all recived fields;
            foreach($aProfileFields as $sKey => $mValue)
            {
            	$mValue = process_db_input($mValue, BX_TAGS_VALIDATE, BX_SLASHES_AUTO);
            	$sKey = process_db_input($sKey, BX_TAGS_STRIP, BX_SLASHES_NO_ACTION);
                $sFields .= "`{$sKey}` = '{$mValue}', ";
            }

            $sFields = preg_replace( '/,$/', '', trim($sFields) );

            $sQuery = "INSERT INTO `Profiles` SET {$sFields}";
            $this -> query($sQuery);

            return db_last_id();
        }

        /**
         * Function will update  profile's status;
         *
         * @param  : $iProfileId (integer) - profile's Id;
         * @param  : $sStatus    (string)  - profile's status;
         * @return : void;
         */
        function updateProfileStatus($iProfileId, $sStatus)
        {
			$iProfileId = (int)$iProfileId;
			$sStatus	= process_db_input($sStatus);

            $sQuery = "UPDATE `Profiles` SET `Status` = '{$sStatus}' WHERE `ID` = {$iProfileId}";
            return $this -> query($sQuery);
        }

        /**
         * Function will check field name in 'Profiles` table;
         *   
         * @param $sFieldName string
         * @return : (boolean);   
         */
        function isFieldExist($sFieldName) 
        {
        	$sFieldName = process_db_input($sFieldName);
            $sQuery = "SELECT `ID` FROM `sys_profile_fields` WHERE `Name` = '{$sFieldName}' LIMIT 1";
            return $this -> getOne($sQuery) ? true : false;
        }

        /**
         * Check existing email 
         * 
         * @param $sEmail string
         * @return boolean
         */
        function isEmailExisting($sEmail)
        {
            $sEmail = process_db_input($sEmail, BX_TAGS_STRIP, BX_SLASHES_AUTO);

            $sQuery = "SELECT COUNT(*) FROM `Profiles` WHERE `Email` = '{$sEmail}'";
            return $this -> getOne($sQuery) ? true : false;
        }

        /**
         * Get country's ISO code;
         *
         * @param : $sCountry (string) - country name;
         * @return: (string); - country ISO code;
         */
        function getCountryCode($sCountry)
        {
        	$sCountry = process_db_input($sCountry);
            $sQuery = "SELECT `ISO2` FROM `sys_countries` WHERE `Country` = '{$sCountry}' LIMIT 1";
            return $this -> getOne($sQuery);
        }

        /**
         * Function will return category's id;
         *
         * @param  : $sCatName (string) - catregory's name;
         * @return : (integer) - category's id;
         */
        function getSettingsCategoryId($sCatName)
        {
        	$sCatName = process_db_input($sCatName);
            return $this -> getOne('SELECT `kateg` FROM `sys_options` WHERE `Name` = "' . $sCatName . '"');
        }
    }
